package demo1.dao.Mapper;

import demo1.pojo.address;
import demo1.pojo.gouwucar;

import java.sql.ResultSet;
import java.sql.Timestamp;
import java.util.List;

public interface userBuyMapper {
    ResultSet selectAll(String userName,String userPwd) throws Exception;
    ResultSet select() throws Exception;
    void insertUserBuy(String userName,String userPwd)throws Exception;
    void updateUserAddress(String userAddress,int gouwuid)throws Exception;//设置默认地址
    void updateUserBuyPwd(String userPwd,int gouwuid)throws Exception;
    void updateUserBuyName(String userName,int gouwuid)throws Exception;
    List<address> selectById(int gouwuid) throws Exception;
    address select(int addressID)throws Exception;
    void updateAddress(String usersAddress,int addressID)throws Exception;//修改一般地址不是默认地址
    void deleteAddress(int addressID)throws Exception;
    void addAddress(String usersAddress,int gouwuid)throws Exception;//添加地址
    List<address> searchAddress(String address,int gouwuid) throws Exception;//模糊查找地址
    void updateMoney(int money,int gouwuid)throws Exception;
    void insertGoods(int gouwuid,int price,String goodsMessage,String goodsName,int goodsGroup)throws Exception;
    int checkGouwucar(int gouwuid,String goodsName,String goodsMessage)throws Exception;
    List<gouwucar> selectAll(int gouwuid)throws Exception;
    List<gouwucar> selectAllByGoodsGroup(int goodsGroup,int gouwuid)throws Exception;
    void deleteGoods(int id)throws Exception;
    void deleteAll(int gouwuid)throws Exception;
    void deleteGoodsByName(int gouwuid,String goodsName,String goodsMessage)throws Exception;
    void deleteOrderForm(int gouwuid)throws Exception;
    void updateGroup(int goodsGroup,int id)throws Exception;
    gouwucar selectByGouwuid(int id)throws Exception;
    ResultSet selectAllBygouwuid(int gouwuid)throws Exception;
    int selectgoodsGroup(int id)throws Exception;
    void insertOrderForm(int money, Timestamp time,int gouwuid,int goodsGroup)throws Exception;
}
